Define CASE in SQL with its Syntax?

Question

Sushant Mishra · Answer

In SQL CASE is used to provide if-then-else type of logic to SQL. It supports two formats, One is a Simple CASE expression, where we compare an expression to static values andand  the second is a Searched CASE expression, where we compare an expression to one or more logical conditionsand 
Simple Case Expresseion Syntaxand 
CASE
expressionWHEN
expression1 THEN expression1[[WHEN
expression2 THEN expression2] [...]] [ELSE expressionN] END
and 
Searched case Expression Syntax
CASEWHEN
Boolean_expression1 THEN expression1[[WHEN
Boolean_expression2 THEN expression2] [...]] [ELSE expressionN] END

interview

Define CASE in SQL with its Syntax?

Sushant Mishra

Can you answer this question?

1 Answers

Liked By